﻿CREATE PROCEDURE [dbo].[proc_Department_GetBmbh_LCM]
	(
		@Department int 
	)
AS
	--DECLARE @mid VARCHAR(2)
	--SELECT @mid=mid FROM Company WHERE Id=(SELECT CompanyId FROM Department WHERE id=@Department)
	--IF(len(@mid)=1)
	--SET @mid='0'+@mid
	--SELECT @mid + bmbh AS bmbh FROM Department WHERE Id=@Department
	--向LCM推送数据时用字段erp_bh
	SELECT erp_bh FROM Department WHERE Id=@Department
	RETURN
